package com.ourteam.product.ui.dao;

import java.util.Arrays;
import java.util.List;
import java.util.Map;
import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;
import org.apache.commons.lang.StringUtils;

/**
 * Template Name : DAO查询对象 Template Version : 1 Template Last Modfiy Date : Sat Aug 19 10:06:32 CST
 * 2017 Auto Generate Date : 2018-12-14 15:15:15 Warning ! This file will be overwrite when
 * regenerate !
 */
public class ProductUITreeRootNodeDAOQueryBean extends BaseQueryBean {

  public ProductUITreeRootNodeDAOQueryBean() {
    super();
  }

  public ProductUITreeRootNodeDAOQueryBean(BaseQueryBean aQueryBean) {
    super(aQueryBean);
  }

  public ProductUITreeRootNodeDAOQueryBean(BaseQueryBean aQueryBean, Map tableReplaceMap) {
    super(aQueryBean, tableReplaceMap);
  }

  public Criteria createCriteria() {

    Criteria criteria = createCriteriaInternal();
    if (oredCriteria.size() == 0) {
      oredCriteria.add(criteria);
    }
    return criteria;
  }

  protected Criteria createCriteriaInternal() {
    return new Criteria(this);
  }

  public void addIdSelectProperty() {
    addIdSelectProperty("id");
  }

  public void addIdSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeRootNodeDAO.Id, aAlias);
    } else {
      addSelectProperty(IProductUITreeRootNodeDAO.Id, "id");
    }
  }

  public void addTreeIdSelectProperty() {
    addTreeIdSelectProperty("treeId");
  }

  public void addTreeIdSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeRootNodeDAO.TreeId, aAlias);
    } else {
      addSelectProperty(IProductUITreeRootNodeDAO.TreeId, "treeId");
    }
  }

  public void addParentIdSelectProperty() {
    addParentIdSelectProperty("parentId");
  }

  public void addParentIdSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeRootNodeDAO.ParentId, aAlias);
    } else {
      addSelectProperty(IProductUITreeRootNodeDAO.ParentId, "parentId");
    }
  }

  public void addNodeIdSelectProperty() {
    addNodeIdSelectProperty("nodeId");
  }

  public void addNodeIdSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeRootNodeDAO.NodeId, aAlias);
    } else {
      addSelectProperty(IProductUITreeRootNodeDAO.NodeId, "nodeId");
    }
  }

  public void addSortIndexSelectProperty() {
    addSortIndexSelectProperty("sortIndex");
  }

  public void addSortIndexSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeRootNodeDAO.SortIndex, aAlias);
    } else {
      addSelectProperty(IProductUITreeRootNodeDAO.SortIndex, "sortIndex");
    }
  }

  public void addAllSelectProperties() {

    addIdSelectProperty();

    addTreeIdSelectProperty();

    addParentIdSelectProperty();

    addNodeIdSelectProperty();

    addSortIndexSelectProperty();
  }

  public static class Criteria extends BaseWhereCriterion<ProductUITreeRootNodeDAOQueryBean> {

    protected Criteria(ProductUITreeRootNodeDAOQueryBean aParentObject) {
      super(aParentObject);
    }

    public Criteria andIdIsNull() {
      addCriterion(IProductUITreeRootNodeDAO.Id + " is null");
      return this;
    }

    public Criteria andIdIsNotNull() {
      addCriterion(IProductUITreeRootNodeDAO.Id + " is not null");
      return this;
    }

    public Criteria andIdIsNotEmpty() {
      addCriterion(
          IProductUITreeRootNodeDAO.Id
              + " is not null AND "
              + IProductUITreeRootNodeDAO.Id
              + " <> ''");
      return this;
    }

    public Criteria andIdIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeRootNodeDAO.Id
              + " is null OR "
              + IProductUITreeRootNodeDAO.Id
              + " = '')");
      return this;
    }

    public Criteria andIdEqualTo(long value) {
      return andIdEqualTo(Long.valueOf(value));
    }

    public Criteria andIdEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.Id + " = ", value, "id");
      return this;
    }

    public Criteria andIdEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.Id);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdNotEqualTo(long value) {
      return andIdNotEqualTo(Long.valueOf(value));
    }

    public Criteria andIdNotEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.Id + " <>", value, "id");
      return this;
    }

    public Criteria andIdNotEqualToOrIsNull(long value) {
      return andIdNotEqualToOrIsNull(Long.valueOf(value));
    }

    public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {

      addCriterion(
          IProductUITreeRootNodeDAO.Id + " is null OR " + IProductUITreeRootNodeDAO.Id + " <>",
          value,
          "id");
      return this;
    }

    public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.Id);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdGreaterThan(long value) {
      return andIdGreaterThan(Long.valueOf(value));
    }

    public Criteria andIdGreaterThan(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.Id + " >", value, "id");
      return this;
    }

    public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.Id);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdGreaterThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdGreaterThanOrEqualTo(long value) {
      return andIdGreaterThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.Id + " >=", value, "id");
      return this;
    }

    public Criteria andIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.Id);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdLessThan(long value) {
      return andIdLessThan(Long.valueOf(value));
    }

    public Criteria andIdLessThan(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.Id + " <", value, "id");
      return this;
    }

    public Criteria andIdLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.Id);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdLessThanOrEqualTo(long value) {
      return andIdLessThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.Id + " <=", value, "id");
      return this;
    }

    public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.Id);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdIn(long[] values) {
      if (values.length == 1) {
        return andIdEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.Id + " in", values, "id");
        return this;
      }
    }

    public Criteria andIdNotIn(long[] values) {
      if (values.length == 1) {
        return andIdNotEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.Id + " not in", values, "id");
        return this;
      }
    }

    public Criteria andIdIn(List<java.lang.Long> values) {

      if (values.size() == 1) {
        return andIdEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeRootNodeDAO.Id + " in", values, "id");
        return this;
      }
    }

    public Criteria andIdNotIn(List<java.lang.Long> values) {
      if (values.size() == 1) {
        return andIdNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeRootNodeDAO.Id + " not in", values, "id");
        return this;
      }
    }

    public Criteria andIdIn(java.lang.Long[] values) {

      if (values.length == 1) {
        return andIdEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.Id + " in", Arrays.asList(values), "id");
        return this;
      }
    }

    public Criteria andIdNotIn(java.lang.Long[] values) {
      if (values.length == 1) {
        return andIdNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.Id + " not in", Arrays.asList(values), "id");
        return this;
      }
    }

    public Criteria andIdIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdBetween(long value1, long value2) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " between", value1, value2, "id");
      return this;
    }

    public Criteria andIdBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " between", value1, value2, "id");
      return this;
    }

    public Criteria andIdNotBetween(long value1, long value2) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " not between", value1, value2, "id");
      return this;
    }

    public Criteria andIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeRootNodeDAO.Id + " not between", value1, value2, "id");
      return this;
    }

    public Criteria andTreeIdIsNull() {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " is null");
      return this;
    }

    public Criteria andTreeIdIsNotNull() {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " is not null");
      return this;
    }

    public Criteria andTreeIdIsNotEmpty() {
      addCriterion(
          IProductUITreeRootNodeDAO.TreeId
              + " is not null AND "
              + IProductUITreeRootNodeDAO.TreeId
              + " <> ''");
      return this;
    }

    public Criteria andTreeIdIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeRootNodeDAO.TreeId
              + " is null OR "
              + IProductUITreeRootNodeDAO.TreeId
              + " = '')");
      return this;
    }

    public Criteria andTreeIdEqualTo(long value) {
      return andTreeIdEqualTo(Long.valueOf(value));
    }

    public Criteria andTreeIdEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.TreeId + " = ", value, "treeId");
      return this;
    }

    public Criteria andTreeIdEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.TreeId);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdNotEqualTo(long value) {
      return andTreeIdNotEqualTo(Long.valueOf(value));
    }

    public Criteria andTreeIdNotEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.TreeId + " <>", value, "treeId");
      return this;
    }

    public Criteria andTreeIdNotEqualToOrIsNull(long value) {
      return andTreeIdNotEqualToOrIsNull(Long.valueOf(value));
    }

    public Criteria andTreeIdNotEqualToOrIsNull(java.lang.Long value) {

      addCriterion(
          IProductUITreeRootNodeDAO.TreeId
              + " is null OR "
              + IProductUITreeRootNodeDAO.TreeId
              + " <>",
          value,
          "treeId");
      return this;
    }

    public Criteria andTreeIdNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.TreeId);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdGreaterThan(long value) {
      return andTreeIdGreaterThan(Long.valueOf(value));
    }

    public Criteria andTreeIdGreaterThan(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.TreeId + " >", value, "treeId");
      return this;
    }

    public Criteria andTreeIdGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.TreeId);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdGreaterThanOrEqualTo(long value) {
      return andTreeIdGreaterThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andTreeIdGreaterThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.TreeId + " >=", value, "treeId");
      return this;
    }

    public Criteria andTreeIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.TreeId);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdLessThan(long value) {
      return andTreeIdLessThan(Long.valueOf(value));
    }

    public Criteria andTreeIdLessThan(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.TreeId + " <", value, "treeId");
      return this;
    }

    public Criteria andTreeIdLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.TreeId);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdLessThanOrEqualTo(long value) {
      return andTreeIdLessThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andTreeIdLessThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.TreeId + " <=", value, "treeId");
      return this;
    }

    public Criteria andTreeIdLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.TreeId);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdIn(long[] values) {
      if (values.length == 1) {
        return andTreeIdEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.TreeId + " in", values, "treeId");
        return this;
      }
    }

    public Criteria andTreeIdNotIn(long[] values) {
      if (values.length == 1) {
        return andTreeIdNotEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.TreeId + " not in", values, "treeId");
        return this;
      }
    }

    public Criteria andTreeIdIn(List<java.lang.Long> values) {

      if (values.size() == 1) {
        return andTreeIdEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeRootNodeDAO.TreeId + " in", values, "treeId");
        return this;
      }
    }

    public Criteria andTreeIdNotIn(List<java.lang.Long> values) {
      if (values.size() == 1) {
        return andTreeIdNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeRootNodeDAO.TreeId + " not in", values, "treeId");
        return this;
      }
    }

    public Criteria andTreeIdIn(java.lang.Long[] values) {

      if (values.length == 1) {
        return andTreeIdEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.TreeId + " in", Arrays.asList(values), "treeId");
        return this;
      }
    }

    public Criteria andTreeIdNotIn(java.lang.Long[] values) {
      if (values.length == 1) {
        return andTreeIdNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.TreeId + " not in", Arrays.asList(values), "treeId");
        return this;
      }
    }

    public Criteria andTreeIdIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdBetween(long value1, long value2) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " between", value1, value2, "treeId");
      return this;
    }

    public Criteria andTreeIdBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " between", value1, value2, "treeId");
      return this;
    }

    public Criteria andTreeIdNotBetween(long value1, long value2) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " not between", value1, value2, "treeId");
      return this;
    }

    public Criteria andTreeIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeRootNodeDAO.TreeId + " not between", value1, value2, "treeId");
      return this;
    }

    public Criteria andParentIdIsNull() {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " is null");
      return this;
    }

    public Criteria andParentIdIsNotNull() {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " is not null");
      return this;
    }

    public Criteria andParentIdIsNotEmpty() {
      addCriterion(
          IProductUITreeRootNodeDAO.ParentId
              + " is not null AND "
              + IProductUITreeRootNodeDAO.ParentId
              + " <> ''");
      return this;
    }

    public Criteria andParentIdIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeRootNodeDAO.ParentId
              + " is null OR "
              + IProductUITreeRootNodeDAO.ParentId
              + " = '')");
      return this;
    }

    public Criteria andParentIdEqualTo(long value) {
      return andParentIdEqualTo(Long.valueOf(value));
    }

    public Criteria andParentIdEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.ParentId + " = ", value, "parentId");
      return this;
    }

    public Criteria andParentIdEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.ParentId);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andParentIdEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andParentIdNotEqualTo(long value) {
      return andParentIdNotEqualTo(Long.valueOf(value));
    }

    public Criteria andParentIdNotEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.ParentId + " <>", value, "parentId");
      return this;
    }

    public Criteria andParentIdNotEqualToOrIsNull(long value) {
      return andParentIdNotEqualToOrIsNull(Long.valueOf(value));
    }

    public Criteria andParentIdNotEqualToOrIsNull(java.lang.Long value) {

      addCriterion(
          IProductUITreeRootNodeDAO.ParentId
              + " is null OR "
              + IProductUITreeRootNodeDAO.ParentId
              + " <>",
          value,
          "parentId");
      return this;
    }

    public Criteria andParentIdNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.ParentId);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andParentIdNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andParentIdGreaterThan(long value) {
      return andParentIdGreaterThan(Long.valueOf(value));
    }

    public Criteria andParentIdGreaterThan(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.ParentId + " >", value, "parentId");
      return this;
    }

    public Criteria andParentIdGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.ParentId);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andParentIdGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andParentIdGreaterThanOrEqualTo(long value) {
      return andParentIdGreaterThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andParentIdGreaterThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.ParentId + " >=", value, "parentId");
      return this;
    }

    public Criteria andParentIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.ParentId);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andParentIdGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andParentIdLessThan(long value) {
      return andParentIdLessThan(Long.valueOf(value));
    }

    public Criteria andParentIdLessThan(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.ParentId + " <", value, "parentId");
      return this;
    }

    public Criteria andParentIdLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.ParentId);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andParentIdLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andParentIdLessThanOrEqualTo(long value) {
      return andParentIdLessThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andParentIdLessThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.ParentId + " <=", value, "parentId");
      return this;
    }

    public Criteria andParentIdLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.ParentId);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andParentIdLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andParentIdIn(long[] values) {
      if (values.length == 1) {
        return andParentIdEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.ParentId + " in", values, "parentId");
        return this;
      }
    }

    public Criteria andParentIdNotIn(long[] values) {
      if (values.length == 1) {
        return andParentIdNotEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.ParentId + " not in", values, "parentId");
        return this;
      }
    }

    public Criteria andParentIdIn(List<java.lang.Long> values) {

      if (values.size() == 1) {
        return andParentIdEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeRootNodeDAO.ParentId + " in", values, "parentId");
        return this;
      }
    }

    public Criteria andParentIdNotIn(List<java.lang.Long> values) {
      if (values.size() == 1) {
        return andParentIdNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeRootNodeDAO.ParentId + " not in", values, "parentId");
        return this;
      }
    }

    public Criteria andParentIdIn(java.lang.Long[] values) {

      if (values.length == 1) {
        return andParentIdEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.ParentId + " in", Arrays.asList(values), "parentId");
        return this;
      }
    }

    public Criteria andParentIdNotIn(java.lang.Long[] values) {
      if (values.length == 1) {
        return andParentIdNotEqualTo(values[0]);
      } else {
        addCriterion(
            IProductUITreeRootNodeDAO.ParentId + " not in", Arrays.asList(values), "parentId");
        return this;
      }
    }

    public Criteria andParentIdIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andParentIdNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andParentIdBetween(long value1, long value2) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " between", value1, value2, "parentId");
      return this;
    }

    public Criteria andParentIdBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " between", value1, value2, "parentId");
      return this;
    }

    public Criteria andParentIdNotBetween(long value1, long value2) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " not between", value1, value2, "parentId");
      return this;
    }

    public Criteria andParentIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeRootNodeDAO.ParentId + " not between", value1, value2, "parentId");
      return this;
    }

    public Criteria andNodeIdIsNull() {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " is null");
      return this;
    }

    public Criteria andNodeIdIsNotNull() {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " is not null");
      return this;
    }

    public Criteria andNodeIdIsNotEmpty() {
      addCriterion(
          IProductUITreeRootNodeDAO.NodeId
              + " is not null AND "
              + IProductUITreeRootNodeDAO.NodeId
              + " <> ''");
      return this;
    }

    public Criteria andNodeIdIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeRootNodeDAO.NodeId
              + " is null OR "
              + IProductUITreeRootNodeDAO.NodeId
              + " = '')");
      return this;
    }

    public Criteria andNodeIdEqualTo(long value) {
      return andNodeIdEqualTo(Long.valueOf(value));
    }

    public Criteria andNodeIdEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.NodeId + " = ", value, "nodeId");
      return this;
    }

    public Criteria andNodeIdEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.NodeId);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNodeIdEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andNodeIdNotEqualTo(long value) {
      return andNodeIdNotEqualTo(Long.valueOf(value));
    }

    public Criteria andNodeIdNotEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.NodeId + " <>", value, "nodeId");
      return this;
    }

    public Criteria andNodeIdNotEqualToOrIsNull(long value) {
      return andNodeIdNotEqualToOrIsNull(Long.valueOf(value));
    }

    public Criteria andNodeIdNotEqualToOrIsNull(java.lang.Long value) {

      addCriterion(
          IProductUITreeRootNodeDAO.NodeId
              + " is null OR "
              + IProductUITreeRootNodeDAO.NodeId
              + " <>",
          value,
          "nodeId");
      return this;
    }

    public Criteria andNodeIdNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.NodeId);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNodeIdNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andNodeIdGreaterThan(long value) {
      return andNodeIdGreaterThan(Long.valueOf(value));
    }

    public Criteria andNodeIdGreaterThan(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.NodeId + " >", value, "nodeId");
      return this;
    }

    public Criteria andNodeIdGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.NodeId);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNodeIdGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andNodeIdGreaterThanOrEqualTo(long value) {
      return andNodeIdGreaterThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andNodeIdGreaterThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.NodeId + " >=", value, "nodeId");
      return this;
    }

    public Criteria andNodeIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.NodeId);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNodeIdGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andNodeIdLessThan(long value) {
      return andNodeIdLessThan(Long.valueOf(value));
    }

    public Criteria andNodeIdLessThan(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.NodeId + " <", value, "nodeId");
      return this;
    }

    public Criteria andNodeIdLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.NodeId);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNodeIdLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andNodeIdLessThanOrEqualTo(long value) {
      return andNodeIdLessThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andNodeIdLessThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeRootNodeDAO.NodeId + " <=", value, "nodeId");
      return this;
    }

    public Criteria andNodeIdLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.NodeId);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNodeIdLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andNodeIdIn(long[] values) {
      if (values.length == 1) {
        return andNodeIdEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.NodeId + " in", values, "nodeId");
        return this;
      }
    }

    public Criteria andNodeIdNotIn(long[] values) {
      if (values.length == 1) {
        return andNodeIdNotEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.NodeId + " not in", values, "nodeId");
        return this;
      }
    }

    public Criteria andNodeIdIn(List<java.lang.Long> values) {

      if (values.size() == 1) {
        return andNodeIdEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeRootNodeDAO.NodeId + " in", values, "nodeId");
        return this;
      }
    }

    public Criteria andNodeIdNotIn(List<java.lang.Long> values) {
      if (values.size() == 1) {
        return andNodeIdNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeRootNodeDAO.NodeId + " not in", values, "nodeId");
        return this;
      }
    }

    public Criteria andNodeIdIn(java.lang.Long[] values) {

      if (values.length == 1) {
        return andNodeIdEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.NodeId + " in", Arrays.asList(values), "nodeId");
        return this;
      }
    }

    public Criteria andNodeIdNotIn(java.lang.Long[] values) {
      if (values.length == 1) {
        return andNodeIdNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.NodeId + " not in", Arrays.asList(values), "nodeId");
        return this;
      }
    }

    public Criteria andNodeIdIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andNodeIdNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andNodeIdBetween(long value1, long value2) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " between", value1, value2, "nodeId");
      return this;
    }

    public Criteria andNodeIdBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " between", value1, value2, "nodeId");
      return this;
    }

    public Criteria andNodeIdNotBetween(long value1, long value2) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " not between", value1, value2, "nodeId");
      return this;
    }

    public Criteria andNodeIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeRootNodeDAO.NodeId + " not between", value1, value2, "nodeId");
      return this;
    }

    public Criteria andSortIndexIsNull() {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " is null");
      return this;
    }

    public Criteria andSortIndexIsNotNull() {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " is not null");
      return this;
    }

    public Criteria andSortIndexIsNotEmpty() {
      addCriterion(
          IProductUITreeRootNodeDAO.SortIndex
              + " is not null AND "
              + IProductUITreeRootNodeDAO.SortIndex
              + " <> ''");
      return this;
    }

    public Criteria andSortIndexIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeRootNodeDAO.SortIndex
              + " is null OR "
              + IProductUITreeRootNodeDAO.SortIndex
              + " = '')");
      return this;
    }

    public Criteria andSortIndexEqualTo(int value) {
      return andSortIndexEqualTo(Integer.valueOf(value));
    }

    public Criteria andSortIndexEqualTo(java.lang.Integer value) {

      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " = ", value, "sortIndex");
      return this;
    }

    public Criteria andSortIndexEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.SortIndex);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andSortIndexEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andSortIndexNotEqualTo(int value) {
      return andSortIndexNotEqualTo(Integer.valueOf(value));
    }

    public Criteria andSortIndexNotEqualTo(java.lang.Integer value) {

      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " <>", value, "sortIndex");
      return this;
    }

    public Criteria andSortIndexNotEqualToOrIsNull(int value) {
      return andSortIndexNotEqualToOrIsNull(Integer.valueOf(value));
    }

    public Criteria andSortIndexNotEqualToOrIsNull(java.lang.Integer value) {

      addCriterion(
          IProductUITreeRootNodeDAO.SortIndex
              + " is null OR "
              + IProductUITreeRootNodeDAO.SortIndex
              + " <>",
          value,
          "sortIndex");
      return this;
    }

    public Criteria andSortIndexNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.SortIndex);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andSortIndexNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andSortIndexGreaterThan(int value) {
      return andSortIndexGreaterThan(Integer.valueOf(value));
    }

    public Criteria andSortIndexGreaterThan(java.lang.Integer value) {

      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " >", value, "sortIndex");
      return this;
    }

    public Criteria andSortIndexGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.SortIndex);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andSortIndexGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andSortIndexGreaterThanOrEqualTo(int value) {
      return andSortIndexGreaterThanOrEqualTo(Integer.valueOf(value));
    }

    public Criteria andSortIndexGreaterThanOrEqualTo(java.lang.Integer value) {

      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " >=", value, "sortIndex");
      return this;
    }

    public Criteria andSortIndexGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.SortIndex);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andSortIndexGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andSortIndexLessThan(int value) {
      return andSortIndexLessThan(Integer.valueOf(value));
    }

    public Criteria andSortIndexLessThan(java.lang.Integer value) {

      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " <", value, "sortIndex");
      return this;
    }

    public Criteria andSortIndexLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.SortIndex);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andSortIndexLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andSortIndexLessThanOrEqualTo(int value) {
      return andSortIndexLessThanOrEqualTo(Integer.valueOf(value));
    }

    public Criteria andSortIndexLessThanOrEqualTo(java.lang.Integer value) {

      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " <=", value, "sortIndex");
      return this;
    }

    public Criteria andSortIndexLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeRootNodeDAO.SortIndex);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andSortIndexLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andSortIndexIn(int[] values) {
      if (values.length == 1) {
        return andSortIndexEqualTo((java.lang.Integer) values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.SortIndex + " in", values, "sortIndex");
        return this;
      }
    }

    public Criteria andSortIndexNotIn(int[] values) {
      if (values.length == 1) {
        return andSortIndexNotEqualTo((java.lang.Integer) values[0]);
      } else {
        addCriterion(IProductUITreeRootNodeDAO.SortIndex + " not in", values, "sortIndex");
        return this;
      }
    }

    public Criteria andSortIndexIn(List<java.lang.Integer> values) {

      if (values.size() == 1) {
        return andSortIndexEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeRootNodeDAO.SortIndex + " in", values, "sortIndex");
        return this;
      }
    }

    public Criteria andSortIndexNotIn(List<java.lang.Integer> values) {
      if (values.size() == 1) {
        return andSortIndexNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeRootNodeDAO.SortIndex + " not in", values, "sortIndex");
        return this;
      }
    }

    public Criteria andSortIndexIn(java.lang.Integer[] values) {

      if (values.length == 1) {
        return andSortIndexEqualTo(values[0]);
      } else {
        addCriterion(
            IProductUITreeRootNodeDAO.SortIndex + " in", Arrays.asList(values), "sortIndex");
        return this;
      }
    }

    public Criteria andSortIndexNotIn(java.lang.Integer[] values) {
      if (values.length == 1) {
        return andSortIndexNotEqualTo(values[0]);
      } else {
        addCriterion(
            IProductUITreeRootNodeDAO.SortIndex + " not in", Arrays.asList(values), "sortIndex");
        return this;
      }
    }

    public Criteria andSortIndexIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andSortIndexNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andSortIndexBetween(int value1, int value2) {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " between", value1, value2, "sortIndex");
      return this;
    }

    public Criteria andSortIndexBetween(java.lang.Integer value1, java.lang.Integer value2) {
      addCriterion(IProductUITreeRootNodeDAO.SortIndex + " between", value1, value2, "sortIndex");
      return this;
    }

    public Criteria andSortIndexNotBetween(int value1, int value2) {
      addCriterion(
          IProductUITreeRootNodeDAO.SortIndex + " not between", value1, value2, "sortIndex");
      return this;
    }

    public Criteria andSortIndexNotBetween(java.lang.Integer value1, java.lang.Integer value2) {
      addCriterion(
          IProductUITreeRootNodeDAO.SortIndex + " not between", value1, value2, "sortIndex");
      return this;
    }
  }
}
